You can access MySQL databases directly through PHP scripts. This lets you read and write data to your database directly from your website.
mysql_connect
statement. For example: $con = mysql_connect('HOSTNAME','USERNAME','PASSWORD');
For help with your mysql_connect
information, see Find your database hostname.
mysql_select_db
. For example: mysql_select_db('DATABASENAME', $con)
Where 'DATABASENAME'
is the name of your database — this also displays on your database's details page.
After establishing the connection and selecting the database, you can query it using PHP.
To help you create your own connection string, we've included an example below.
This connect string will look in a database (your_dbusername
, find a particular table (your_tablename
), and then list all values in that table for a field (i.e. column) you specify (your_field
).
<?php //Sample Database Connection Syntax for PHP and MySQL. //Connect To Database $hostname="your_hostname"; $username="your_dbusername"; $password="your_dbpassword"; $dbname="your_dbusername"; $usertable="your_tablename"; $yourfield = "your_field"; mysql_connect($hostname,$username, $password) or die ("<html><script language='JavaScript'>alert('Unable to connect to database! Please try again later.'),history.go(-1)</script></html>"); mysql_select_db($dbname); # Check If Record Exists $query = "SELECT * FROM $usertable"; $result = mysql_query($query); if($result){ while($row = mysql_fetch_array($result)){ $name = $row["$yourfield"]; echo "Name: ".$name."<br/>"; } }?>
For more information, see the MySQL Functions page at php.net.